Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_8650

R_8650

MedicalProductDefinition

MedicalProductDetails

MedicalProductDefinitionID

 

 

R_8760

R_8760

StockItemQuantity

LPerfResPerfContrServ

StockItemQuantityID

 

 

R_8877

R_8877

Service

LContractService

ServID

 

 

R_8878

R_8878

Contract

LContractService

ContractID

 

 

R_8914

R_8914

LPatientInsurer

LPatientInsurerIdentifier

LPatientInsurerID

 

 

R_8915

R_8915

IdentifierType

LPatientInsurerIdentifier

IdentifierTypeID

 

 

R_8932

R_8932

BenefitPlanContract

LEventContractor

BenefitPlanContractID

 

 

R_8982

R_8982

Contract

LContractUser

ContractID

 

 

R_8983

R_8983

UserDefinition

LContractUser

PersonID

 

 

R_8984

R_8984

Contract

LContractUserType

ContractID

 

 

R_8985

R_8985

UserType

LContractUserType

UserTypeID

 

 

R_9185

R_9185

Contract

LEventContractor

ContractID

 

 

R_9669

R_9669

Visit

LEventContractor

VisitID

 

 

R_10227

R_10227

StockItemQuantityDetails

StockItemQuantity

StockItemQuantityDetailsID

 

 

R_10314

R_10314

BenefitPlanContract

PerfServiceFinanceDetails

BenefitPlanContractID

 

 

R_10315

R_10315

PerfService

PerfServiceFinanceDetails

PerfServiceID

 

 

R_10323

R_10323

ActiveIngredientGroup

ActiveIngredientGroupDetails

activeIngredientGroupId

 

 

R_10324

R_10324

ActiveIngredientGroup

MedicalProductDefinition

ActiveIngredientGroupID

 

 

R_10325

R_10325

DictionaryValue

ActiveIngredientGroupDetails

typeId

 

 

R_10326

R_10326

DictionaryValue

ActiveIngredientGroup

measureId

 

 


1  2